Naloxone data from DPH

1: dph_dash_ems_naloxone_zip.csv

  • two columns: zip code, count
  • unsure if zip code is incident location or location of person who acquired the naloxone
  • 2018 data?
## Loading required package: sp
## Warning: package 'sp' was built under R version 3.5.3

2: dph_dash_n_naloxone_admins

  • by year & quarter
## Warning: Removed 25 rows containing missing values (geom_path).

OD data from DPH

1 dph_od_incident_counts

  • by year & quarter
  • if count 0-5, then only specified as <6

2 dph_od_resident_counts

  • same setup as dph_od_incident counts (ZIPCODE now named Zip.Code)

Compare the “incident” and “resident” files by year and zip

Prevention point data

pp_refill_events.csv

  • 30 variables
    • demographics: age, gender, race
    • use info: n_pp_refill, n_o_refill, n_ods, n_admins, n_revivals, used_naloxone, cpr_used
    • outcome & transfer to: outcome, outcome_ems, outcome_police, outcome_ed, outcome_death, outcome_unk, outcome_ok
    • drug: od_drug, od_drug_heroin, od_drug_cocain, od_drug_fentanyl, od_drug_unknown, od_drug_other
    • physical status: od_present, od_present_breath, od_present_unresponsive, od_present_coloring, od_present_other
    • data date range: 2018-q1-q2, 2018-q3-q4
  • Notes
    • more than one drug may be present
    • more than one outcome type may be present 3771 observations
      gender count
      f 1333
      m 2399
race count
ai 20
asian 19
black 532
hispanic 218
latino 213
mixed 40
multiracial 14
other 17
white 2386
date range count
2018-q1-q2 1236
2018-q3-q4 2535 
## No id variables; using all as measure variables
## Warning: Removed 6172 rows containing missing values (position_stack).
## No id variables; using all as measure variables
## Warning: Removed 2280 rows containing missing values (position_stack).
## No id variables; using all as measure variables
## Warning: Removed 2069 rows containing missing values (position_stack).

pp_refill_zipcode_metrics

  • appears to be summary data of previous sheet, but with the addition of zip code (one line per zip)
  • shiny app for viewing already created

PSP data (State-wide data)

psp_overdose_events.csv

  • Date (1/1/2018-1/15/2020), time, day of week
  • Incident info: county, state
  • Victim demographics: gender, age, race, ethnicity
  • Accidental exposure (Y/N)
  • Suspected drugs
  • Whether naloxone was administered and, if so, dose count, dose unit
  • Response time (to Naloxone??): <1 minute, , 1-3minutes, >5 minutes, did not work
  • Survived: Y/N/U
  • Response (to naloxone?) description: i.e. combative, no response to nalxone, responsive and alert
  • Revive action description: i.e. arrest, hospital conscious, hospital unconscious, refused transport
  • Third party admin description: EMS, Fire department

removed 2020 data from dataset for analysis
removed accidental exposure == Y observations (17 records)
15121 incidents
201 incidents in Philadelphia

Suspected Drugh count
ALCOHOL 274
BARBITURATES (I.E. AMYTAL, NEMBUTAL, ETC) 19
BATH SALTS 10
BENZODIAZEPINES (I.E.VALIUM, XANAX, ATIVAN, ETC) 276
CARFENTANIL 83
COCAINE/CRACK 367
FENTANYL 1954
FENTANYL ANALOG/OTHER SYNTHETIC OPIOID 281
HEROIN 8133
MARIJUANA 187
METHADONE 64
METHAMPHETAMINE 261
OTHER 341
PHARMACEUTICAL OPIOID 441
PHARMACEUTICAL OTHER 275
PHARMACEUTICAL STIMULANT 20
SUBOXONE 114
SYNTHETIC MARIJUANA 138
UNKNOWN 1640